package by.bsu.scs.db.dao;

// Generated 05.03.2011 11:02:55 by Hibernate Tools 3.4.0.CR1

import java.sql.Date;
import java.sql.Timestamp;
import java.text.MessageFormat;
import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.hibernate.LockMode;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;

import by.bsu.scs.model.Task;
import by.bsu.scs.model.User;
import by.bsu.scs.util.db.HibernateUtil;
import by.bsu.scs.util.manager.PropertyManager;

/**
 * Home object for domain model class Task.
 * @see by.bsu.scs.model.Task
 * @author Hibernate Tools
 */
public class TaskHome {

	private static final Logger LOGGER = Logger.getLogger(TaskHome.class);
	
	private Session session = null;
	private Transaction transaction = null;

	public void persist(Task transientInstance) {
		LOGGER.info("persisting Task instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.save(transientInstance);
			transaction.commit();
			LOGGER.info("persist successful");
		} catch (HibernateException e) {
            transaction.rollback();
            LOGGER.error("persist failed", e.getCause());
        }
	}

	public void attachDirty(Task instance) {
		LOGGER.info("attaching dirty Task instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.saveOrUpdate(instance);
			transaction.commit();
			LOGGER.info("attach successful");
		} catch (HibernateException e) {
            transaction.rollback();
            LOGGER.error("attach failed", e.getCause());
        }
	}

	@SuppressWarnings("deprecation")
	public void attachClean(Task instance) {
		LOGGER.info("attaching clean Task instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.lock(instance, LockMode.NONE);
			transaction.commit();
			LOGGER.info("attach successful");
		} catch (HibernateException e) {
            transaction.rollback();
            LOGGER.error("attach failed", e.getCause());
        }
	}

	public void delete(Task persistentInstance) {
		LOGGER.info("deleting Task instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.delete(persistentInstance);
			transaction.commit();
			LOGGER.info("delete successful");
		} catch (HibernateException e) {
            transaction.rollback();
            LOGGER.error("delete failed", e.getCause());
        }
	}

	public Task merge(Task detachedInstance) {
		LOGGER.info("merging Task instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			Task result = (Task) session.merge(detachedInstance);
			transaction.commit();
			LOGGER.info("merge successful");
			return result;
		} catch (HibernateException e) {
            transaction.rollback();
            LOGGER.error("merge failed", e.getCause());
            return null;
        }
	}

	public Task findById(int id) {
		LOGGER.info("getting Task instance with id: " + id);
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			Task instance = (Task) session.get(
					"by.bsu.scs.model.Task", id);
			if (instance == null) {
				LOGGER.info("get successful, no instance found");
			} else {
				LOGGER.info("get successful, instance found");
			}
			transaction.commit();
			return instance;
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("get failed", e.getCause());
			return null;
		}
	}

	@SuppressWarnings("rawtypes")
	public List findByExample(Task instance) {
		LOGGER.info("finding Task instance by example");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			Example example = Example.create(instance).excludeZeroes();
			List results = session.createCriteria("by.bsu.scs.model.Task")
					.add(example).list();
			LOGGER.info("find by example successful, result size: "
					+ results.size());
			transaction.commit();
			return results;
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("find by example failed", e.getCause());
			return null;
		}
	}
	
	// ****************************Methods added***********************
	
	public List<Task> getTasksByStudentIdSQL(User student) {
		LOGGER.info("finding tasks by student id");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();

			String sql = PropertyManager.getInstance().getProperty(
					PropertyManager.TASK_BY_STUDENT_ID_SQL);
			Object[] params = { student.getUserId() };
			MessageFormat messageToFormat = new MessageFormat(sql);
			sql = messageToFormat.format(params);

			List results = session.createSQLQuery(sql).list();

			LOGGER.info("find successful, result size: " + results.size());
			transaction.commit();
			return parseTaskData(results);
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("find tasks by student id failed", e.getCause());
			return null;
		}
	}
	
	public List<Task> parseTaskData(List results){
		List<Task> taskList = new ArrayList<Task>();
		for (Object o : results) {
			Object[] taskData = (Object[]) o;
			Task task = new Task();
			task.setTaskId((Integer)taskData[0]);
			task.setTaskDescription((String)taskData[1]);
			task.setTaskTitle((String)taskData[2]);
			task.setCreationDate(new Date(((Timestamp)taskData[3]).getTime()));
			task.setMaxUpload((Integer)taskData[4]);
			task.setMarkPolicy(new MarkPolicyHome().findById((Integer)taskData[5]));
			taskList.add(task);
		}
		return taskList;
	}
}
